<?php
	session_start();
	include ("../includes/conn.php");

	extract($_REQUEST, EXTR_PREFIX_ALL|EXTR_REFS, 'v');
	$csn=$v_csn;
	$ssn=$v_ssn;
	$dsn=$v_dsn;
	$catno=$v_catno;

	$pdsql="select * from category where sn='$csn'";
			$pdres=mysql_query($pdsql,$db);
			$pdrw=mysql_num_rows($pdres);
			if ($pdrw>0){
				$pdr=mysql_fetch_array($pdres);
				$catname = $pdr['cname'];
			}
	$pdsql="select * from subcat where sn='$ssn'";
			$pdres=mysql_query($pdsql,$db);
			$pdrw=mysql_num_rows($pdres);
			if ($pdrw>0){
				$pdr=mysql_fetch_array($pdres);
				$subcatname = $pdr['sname'];
			}
	$pdsql="select * from chdcat where sn='$dsn'";
			$pdres=mysql_query($pdsql,$db);
			$pdrw=mysql_num_rows($pdres);
			if ($pdrw>0){
				$pdr=mysql_fetch_array($pdres);
				$type = $pdr['dname'];
			}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<?php include('../includes/title.php');?>
<script language="Javascript1.2">
  <!--
  function printpage() {
  window.print();
  }
  //-->
</script>
<style type="text/css">
#topprint {
	width:660px;
	border-bottom:2px dotted #000;
	float:left;
	padding-bottom:5px;
}
#printlogo {
	padding-left:15px;
	float:left;
}
#printtitle {
	float:right;
	padding-top:10px;
	padding-right:20px;
	font-size:12px;
	text-align:right;
}
#pname {
	margin-top:80px;
	padding:20px 20px 0px 20px;
	font-size:20px;
	text-align:center;
}
#inventorya {
	float:left;
	padding:10px;
	width:140px;
}
sup {
	vertical-align:top;
	font-size:8px;
}
#line {
	float:left;
	width:660px;
	border-bottom:solid 1px #000;
}
#printcaution {
	padding-top:15px;
	width:660px;
	border-top:solid 1px #000;
	text-align:center;
	font-size:8px;
	font-style:italic;
}
 @media screen, print {
* {
	margin:0;
	padding:0;
}
#printDetail {
	width:660px;
	margin-top:2px;
	margin-left:15px;
	text-align:left;
	float:left;
}
}
 @media screen, print {
html, body {
	font-family:Arial, Helvetica, sans-serif;
	font-size:12px;
}
}
#title {
	font-size:24px;
	font-weight:bold;
}
span {
	font-weight:bold;
}
</style>
</head>
<body onload='printpage()'>
<div id='printDetail'>
  <?php
	$pdsql="select * from prodProteinVector where catNo='$catno'";
	$pdres=mysql_query($pdsql,$db);
	$pdrw=mysql_num_rows($pdres);
	if ($pdrw>0){
		while ($pdr=mysql_fetch_array($pdres)){
			//display title
			echo "
				<div id='topprint'>
					<div id='printlogo'><img src='/images/logoforPntJANUARY2011.png' width='300px' height='83px' /></div>
						<div id='printtitle'><span>Applied Biological Materials Inc.</span><br/>Telephone: 1-866-757-2414<br/>Email: info@abmgood.com<br/>Website: www.abmGood.com</div>
				</div>
			";//end title
			echo "
				<div id='pname'>".$pdr['pname']."</div>
				<div id='inventorya'><span>Cat. No.</span><br/>".$pdr['catNo']."</div>
				<div id='inventorya'><span>Quantity</span><br/>".$pdr['quantity']."</div>
				<div id='inventorya'><span>Accession Number</span><br/>".$pdr['AccessionNumber']."</div>
				<div id='line'></div>
				<table width='100%' border='0px' cellpadding='3px' cellspacing='8px' class='contprnt' style='margin-left:8px; margin-top:0px;'>
								<tr height='0px'>
									<td width='120px'></td>
									<td valign='top'></td>
								 </tr>";
								if ($pdr['Description']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Description</span></td>
										<td valign='top'>".$pdr['Description']."</td>
									  </tr>";
								}
								if ($pdr['SpeciesofGenes']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Species</span></td>
										<td valign='top'>".$pdr['SpeciesofGenes']."</td>
									  </tr>";
								}
								if ($pdr['AccessionNumber']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Accession Number</span></td>
										<td valign='top'>".$pdr['AccessionNumber']."</td>
									  </tr>";
								}
								if ($pdr['AccessionLink']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Other Accession Number</span></td>
										<td valign='top'>".$pdr['AccessionLink']."</td>
									  </tr>";
								}
								if ($pdr['Vector']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Vector</span></td>
										<td valign='top'>".$pdr['Vector']."</td>
									  </tr>";
								}
								if ($pdr['Promoter']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Promoter</span></td>
										<td valign='top'>".$pdr['Promoter']."</td>
									  </tr>";
								}
								if ($pdr['BackboneSize']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Vector Size</span></td>
										<td valign='top'>".$pdr['BackboneSize']."</td>
									  </tr>";
								}
								if ($pdr['InsertSize']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Insert Size</span></td>
										<td valign='top'>".$pdr['InsertSize']."</td>
									  </tr>";
								}
								if ($pdr['Tags']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Tags</span></td>
										<td valign='top'>".$pdr['Tags']."</td>
									  </tr>";
								}
								if ($pdr['SelectionMarker']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Selection Marker</span></td>
										<td valign='top'>".$pdr['SelectionMarker']."</td>
									  </tr>";
								}
								if ($pdr['Format']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Format</span></td>
										<td valign='top'>".$pdr['Format']."</td>
									  </tr>";
								}
								if ($pdr['Appearance']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Appearance</span></td>
										<td valign='top'>".$pdr['Appearance']."</td>
									  </tr>";
								}
								if ($pdr['StorageBuffer']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Storage Buffer</span></td>
										<td valign='top'>".$pdr['StorageBuffer']."</td>
									  </tr>";
								}
								if ($pdr['StorageConditions']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Storage</span></td>
										<td valign='top'>".$pdr['StorageConditions']."</td>
									  </tr>";
								}
			echo "
				</table><br/>
				<div id='printcaution'><span>Caution:</span> This product is for research use only and is not intended for therapeutic or diagnostic applications.<br/>Please contact a technical service representative for more information (1-866-757-2414).
				</div>
			";
		}
	}
?>
</div>
</body>
<!-- Piwik -->
<script type="text/javascript">
var pkBaseURL = (("https:" == document.location.protocol) ? "https://abmgood.com/piwik/" : "http://abmgood.com/piwik/");
document.write(unescape("%3Cscript src='" + pkBaseURL + "piwik.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var piwikTracker = Piwik.getTracker(pkBaseURL + "piwik.php", 1);
piwikTracker.trackPageView();
piwikTracker.enableLinkTracking();
} catch( err ) {}
</script>
<noscript>
<p><img src="http://abmgood.com/piwik/piwik.php?idsite=1" style="border:0" alt=""/></p>
</noscript>
<!-- End Piwik Tag -->
</html>
